select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and a.houseType = 3 and (b.cnpropertyname like '%Old house in Fumin Road%' or b.enpropertyname like '%Old house in Fumin Road%') order by updateTime Desc, a.dftpic desc
2nd floor, 3rd floor and fouth floor, one bedroom with south direction and one small room, the master bedroom with large round balcony, bathroom with bath tub
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...
